******************************************************
**LC3 SURVEYS DATA ANALYSIS**********
**Last Edit: September 29, 2022, by KB**********************
******************************************************


use "data/Uganda_LC3survey_projectlevelobs.dta", clear

************
**FIGURE A1**
************

*see R code for graph

bysort internationalfunds2 NGO_fix: tab q9_involved if GGP==0 & noGGPdata!=1
tab q9_involved if GGP==1
bysort internationalfunds2 NGO_fix: tab lobbied if GGP==0 & noGGPdata!=1
tab lobbied if GGP==1
bysort internationalfunds2 NGO_fix: tab helpedbureaucracy if GGP==0 & noGGPdata!=1
tab helpedbureaucracy if GGP==1
bysort internationalfunds2 NGO_fix: tab monitoringcommittee if GGP==0 & noGGPdata!=1
tab monitoringcommittee if GGP==1
bysort internationalfunds2 NGO_fix: tab organizedcommunity if GGP==0 & noGGPdata!=1
tab organizedcommunity if GGP==1


****************************
